Comprehensive Hotel Revenue Forecast & Budget Builder (Excel XLSX)

This is the ultimate detail oriented Hotel Revenue Forecast & Budget builder template. In line with USAH guidelines it covers everything there is that needs to be considered when it comes to Hotel Revenues and Revenue Segments. Key ratios as well to easily see how each revenue segment is contributing to the overall total revenue:

Rooms:
Rooms revenue sheet covers up to 5 most popular typical hotel room types
Build each room types revenues uniquely
Detail the number of room type in your hotel
Populate the expected rooms you expect to be occupied each month
What rate is that room type looking to generate
How many guests in each room? Single and double occupancy stats
View you RevPAR per room type and overall Hotel rooms as well


Food & Beverage:
F & B revenue sheet covers up to 5 outlets as well
Build each outlet revenues individually
Detail the number of covers expected per outlet
Forecast expected average check per cover per outlet
Determine the food and beverage split of your outlet revenues
Split between breakfast revenues as well as outlet consumptions


Meeting & Events:
M & E revenue sheet covers up to the 3 main categories and meeting room types in a typical Hotel
Build each venue revenues individuallyForecast your revenue per serving period: Coffee breaks, lunch & dinner
Individually indicate average check per serving period
Determine the food and beverage related M & E revenue splits
Takes account of other M & E related revenue such as Room rental, Equipment rental, Audi visual


Other Operating Department:
OOD revenue sheet covers up to 4 main outlets in a typical Hotel
Build each outlet revenues individually
Forecast revenue per outlet: Airport transfers, Laundry, Gym & SPA
Dynamic revenue drivers for each different type of outlet revenues within the OOD department


Summary:
Summary sheet takes care of all your inputs from all the above sheets to easily view your Hotel's revenue output across its various segments
Revenue share percentage statistics to see how much each segment is contributing to your overall total Hotel revenue
Key ratios to see the driving factors and engine room behind your Hotel revenues


Sit back and enjoy using this detailed yet super easy to use template and take full control of your Hotel revenue performance!